<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.vsg.stock.basic.domain.mybatis.VolCharacterKlineDailyProxy">


	<resultMap id="VolCharacterKlineDailyResult" type="org.vsg.stock.basic.domain.mybatis.VolCharacterKlineDailyProxy">
		<id property="id.stockCode" column="stock_code" />
		<id property="id.stockStartDate" column="stock_date_start" />
		<result property="stockEndDate" column="stock_date_end"/>
		<result property="levelGolden" column="level_golden"/>
		<result property="goldenDate" column="golden_date"/>
	</resultMap>


	<select id="findVolCharacKlineDailyInCycleByStck"  
		resultMap="VolCharacterKlineDailyResult" 
		parameterType="map"
		>
    	select 
    		STOCK_CODE , STOCK_DATE_START , STOCK_DATE_END, LEVEL_GOLDEN , GOLDEN_DATE 
    	from VOL_CHARACTER_KLINE_DAILY 
    	where 
    		STOCK_CODE = #{stockCode} 
    		and STOCK_DATE_START &gt;= #{stockStartDate} and STOCK_DATE_START &lt;= #{stockDateEnd} order by GOLDEN_DATE
  	</select>


</mapper>
